| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing the day of the week
hi all !!
in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
recognizing the day of the week
sorry again..
exactly i need a true if today it is monday , or friday.. tx !! "pls123" wrote: hi all !! in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
recognizing the day of the week
You can use this to get your TRUE result...
=WEEKDAY(NOW())=2 The number use at the end of the formula corresponds to the day of the week, so Sunday=1, Monday=2, Tuesday=3, etc. -- Rick (MVP - Excel) "pls123" wrote in message ... sorry again.. exactly i need a true if today it is monday , or friday.. tx !! "pls123" wrote: hi all !! in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
recognizing the day of the week
ty rick !!
"Rick Rothstein" wrote: You can use this to get your TRUE result... =WEEKDAY(NOW())=2 The number use at the end of the formula corresponds to the day of the week, so Sunday=1, Monday=2, Tuesday=3, etc. -- Rick (MVP - Excel) "pls123" wrote in message ... sorry again.. exactly i need a true if today it is monday , or friday.. tx !! "pls123" wrote: hi all !! in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
recognizing the day of the week
you could also
=OR(TEXT(TODAY(),"ddd")="Mon",TEXT(TODAY(),"ddd")= "Fri") "pls123" wrote in message ... ty rick !! "Rick Rothstein" wrote: You can use this to get your TRUE result... =WEEKDAY(NOW())=2 The number use at the end of the formula corresponds to the day of the week, so Sunday=1, Monday=2, Tuesday=3, etc. -- Rick (MVP - Excel) "pls123" wrote in message ... sorry again.. exactly i need a true if today it is monday , or friday.. tx !! "pls123" wrote: hi all !! in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
recognizing the day of the week
tx!
"Patrick Molloy" wrote: you could also =OR(TEXT(TODAY(),"ddd")="Mon",TEXT(TODAY(),"ddd")= "Fri") "pls123" wrote in message ... ty rick !! "Rick Rothstein" wrote: You can use this to get your TRUE result... =WEEKDAY(NOW())=2 The number use at the end of the formula corresponds to the day of the week, so Sunday=1, Monday=2, Tuesday=3, etc. -- Rick (MVP - Excel) "pls123" wrote in message ... sorry again.. exactly i need a true if today it is monday , or friday.. tx !! "pls123" wrote: hi all !! in vbe, how can i recognize the day of the week, starting form a now< in cell A1 ?? tx all !! paolo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
