How do I set a cell to auto populate the date to show the current week's Friday date?

  • Thread starter Thread starter SaipanRick
  • Start date Start date
S

SaipanRick

I have a weekly report I want to auto populate the week ending date which is
Friday each week. How would I do this?
 
Hi
Try
=TODAY()-WEEKDAY(TODAY())+6
Click to expand...
On a related note, how could I get a cell to display next month's
name+year?

I tried =month(today())+1, which correctly gave me the month number, but
when I formatted the cell to 'mmmm yyyy' it came up with 'January 1900',
rather than 'March 2008' which I wanted.
 
On a related note, how could I get a cell to display next month's
name+year?

I tried =month(today())+1, which correctly gave me the month number, but
when I formatted the cell to 'mmmm yyyy' it came up with 'January 1900',
rather than 'March 2008' which I wanted.
Click to expand...

The month number (plus one) is not a date, it is a small number, so
formatting it as a date won't work. Try this formula instead (and format the
cell as you have already shown)...

=DATE(YEAR(NOW()),MONTH(NOW())+1,1)

Rick
 
The month number (plus one) is not a date, it is a small number, so
formatting it as a date won't work. Try this formula instead (and
format the cell as you have already shown)...

=DATE(YEAR(NOW()),MONTH(NOW())+1,1)
Click to expand...
Thank you - that did the trick! :)
 
Back
Top