View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Celtic_Avenger[_33_] Celtic_Avenger[_33_] is offline
external usenet poster
 
Posts: 1
Default Next Friday's Date Using Cell Formulae

I have within my spreadsheet the requirement for two dates to be shown.

The first is simple to create, todays date.

Today()

The second requires a little more knowledge to obtain.

I need the second date to show the date of the next friday afte
Today's date, unless todays date is a friday, and then the second dat
will also whow today's date.

Thanks for any help you can give!

Celtic_Avenger
:confused

--
Message posted from http://www.ExcelForum.com