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

[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?

 

[Roger Govier]

Hi
Try
=TODAY()-WEEKDAY(TODAY())+6

 

[Paul Hyett]

Hi
Try
=TODAY()-WEEKDAY(TODAY())+6

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.

 

[Rick Rothstein \(MVP - VB\)]

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.

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

 

[Paul Hyett]

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)

Thank you - that did the trick!