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 |