| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function formula that will return the date of a specific week
I am trying to set up a date field in a spreadsheet that will always give the
date of the upcoming Saturday. I have tried the "Weekday" function along with the "If" and the "If/Or" statements without success. Can someone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Function formula that will return the date of a specific week
try
=TODAY()-WEEKDAY(TODAY())+7 -- Don Guillett SalesAid Software "Greg" wrote in message ... I am trying to set up a date field in a spreadsheet that will always give the date of the upcoming Saturday. I have tried the "Weekday" function along with the "If" and the "If/Or" statements without success. Can someone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Function formula that will return the date of a specific week
Greg --
Here's something. Tried it and it seems to work. If today's date is in cell A1: =A1+(7-WEEKDAY(A1)) HTH "Greg" wrote: I am trying to set up a date field in a spreadsheet that will always give the date of the upcoming Saturday. I have tried the "Weekday" function along with the "If" and the "If/Or" statements without success. Can someone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Function formula that will return the date of a specific week
Hi
Try this: =A2+(7-WEEKDAY(A2)) with your date in A2 Hope this helps. Andy. "Greg" wrote in message ... I am trying to set up a date field in a spreadsheet that will always give the date of the upcoming Saturday. I have tried the "Weekday" function along with the "If" and the "If/Or" statements without success. Can someone help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Function formula that will return the date of a specific week
try:
=TODAY()+7-WEEKDAY(TODAY()) "Greg" wrote: I am trying to set up a date field in a spreadsheet that will always give the date of the upcoming Saturday. I have tried the "Weekday" function along with the "If" and the "If/Or" statements without success. Can someone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Saved Date Formula / Function | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| In Excel How do I return the Month for a specific date | Excel Discussion (Misc queries) | |||
| function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
Hybrid Mode
